select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 2 and (b.cnpropertyname like '%Old House in TaiAn Road%' or b.enpropertyname like '%Old House in TaiAn Road%') order by updateTime Desc, a.dftpic desc
The fusion of beton and wood Taian Rd, free you body and heart in equanimity. To enjoy it, you need to observe it from outside to inside. To make it Attractive ...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...